SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweDesignaciones
AS
SELECT idVacante AS id, Concurso, AgenteDesignado, SitRevDesignado, CategoriaTituloDesignado, FechaDesignacion, PuntajeDesignacion, 
               OrdenDesignacion, Baja, FechaBaja
FROM  dbo.tb_Vacantes
GO
GRANT SELECT ON  [dbo].[vweDesignaciones] TO [CentroDeDesignaciones]
GRANT INSERT ON  [dbo].[vweDesignaciones] TO [CentroDeDesignaciones]
GRANT DELETE ON  [dbo].[vweDesignaciones] TO [CentroDeDesignaciones]
GRANT UPDATE ON  [dbo].[vweDesignaciones] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweDesignaciones] TO [SoloVer]
GO
